CellRange.FillData Method

Fills the data in this range according to the current data and the specified options.

Namespace: MindFusion.Spreadsheet.Wpf
Assembly: MindFusion.Spreadsheet.Wpf

 Syntax

C#

public void FillData (
    FillType type,
    FillDirection direction,
    FillDate date,
    double step,
    Nullable<Double> stop,
    bool trend
)

Visual Basic

Public Sub FillData( _
    type As FillType, _
    direction As FillDirection, _
    date As FillDate, _
    step As Double, _
    stop As Nullable(Of Double), _
    trend As Boolean _
)

 Parameters

type

The fill type.

direction

The fill direction.

date

The date component to increment when the fill type is Date. This parameter is ignored for any of the other fill types.

step

The increment step. This parameter is ignored if the fill type is Auto or when using linear or growth trend.

stop

The fill restriction. The fill will stop when the running value exceeds this restriction. This parameter is ignored if the fill type is Auto or when using linear or growth trend.

trend

A flag indicating whether to use linear or growth trend. This flag can be combined with the Linear and Growth fill types to specify the actual trend.